# Column
# sequence Column name  Type     Size  Description
# -------- ------------ -------  ----  ---------------------
# 1        ent_num     number          unique record
#                                      identifier/unique
#                                      listing identifier
# 2        SDN_Name     text     350   name of SDN
# 3        SDN_Type     text     12    type of SDN
# 4        Program      text     50    sanctions program name
# 5        Title        text     200   title of an individual
# 6        Call_Sign    text     8     vessel call sign
# 7        Vess_type    text     25    vessel type
# 8        Tonnage      text     14    vessel tonnage
# 9        GRT          text     8     gross registered tonnage
# 10       Vess_flag    text     40    vessel flag
# 11       Vess_owner   text     150   vessel owner
# 12       Remarks      text     1000  remarks on SDNclass CreateNames < ActiveRecord::Migration
class CreateNames < ActiveRecord::Migration
  def self.up
    create_table :names do |t|
      t.string 'sdn_name'
      t.string 'sdn_type'
      t.string 'program' 
      t.string 'title'
      t.string 'call_sign'
      t.string 'vess_type'
      t.string 'tonnage'
      t.string 'grt'
      t.string 'vess_flag'
      t.string 'vess_owner'
      t.text 'remarks'
      t.timestamps
    end
  end

  def self.down
    drop_table :names
  end
end
